<?php
/**
 * ShopEx licence edit by kim
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['business_basicmsg']=array (
  'columns' =>
  array (
	//=====================================供应商基本信息===============================
    'business_id' =>
    array (
      'type' => 'number',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => app::get('b2c')->_('供应商信息ID'),
      'width' => 150,
      'comment' => app::get('b2c')->_('供应商信息ID'),
      'editable' => false,
	  'filtertype' => 'yes',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
    'member_id' =>
    array (
      'type' => 'table:members',
      'default' => 0,
      'required' => true,
      'editable' => false,
      'comment' => app::get('b2c')->_('会员ID'),
	  'label' => app::get('b2c')->_('会员用户名'),
	  'filtertype' => 'yes',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'chinese_all_name' =>
    array (
      'type' => 'varchar(100)',
      'label' => app::get('b2c')->_('中文全称'),
      'width' => 180,
      'comment' => app::get('b2c')->_('中文全称'),
      'editable' => true,
      'in_list' => true,
      'default_in_list' => true,
    ),
	'english_all_name' =>
    array (
      'type' => 'varchar(100)',
      'label' => app::get('b2c')->_('英文全称'),
      'width' => 180,
	  'searchtype' => 'has',
      'is_title' => true,
      'comment' => app::get('b2c')->_('英文全称'),
      'editable' => true,
      'in_list' => true,
      'default_in_list' => true,
    ),
	'company_area' => 
    array (
      'label' => app::get('b2c')->_('所在地区'),
      'width' => 110,
      'type' => 'region',
      'editable' => false,
      'filtertype' => 'yes',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'russia_all_name' =>
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('在俄公司名称'),
      'width' => 180,
      'is_title' => true,
      'comment' => app::get('b2c')->_('在俄公司名称'),
      'editable' => true,
      'in_list' => true,
      'default_in_list' => true,
    ),
	'company_addr' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('在俄公司地址'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'in_list' => true,
      'default_in_list' => false,
      
    ),
	//=====================================公司联系人===============================
	'company_rname1' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('联系人姓名1(俄语)'),
      'width' => 75,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),   
	'company_cname1' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('联系人姓名1(汉语)'),
      'width' => 75,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'phone_setting1' => 
    array(
       'type' => 'varchar(20)',
       'editable' => false,
       'comment' => app::get('b2c')->_('电话区号1'),
    ),
	'company_tel1' => 
    array (
      'type' => 'varchar(30)',
      'label' => app::get('b2c')->_('联系人电话1'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'company_weixin1' => 
    array (
      'type' => 'varchar(50)',
      'label' => app::get('b2c')->_('联系人微信1'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'company_rname2' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('联系人姓名2(俄语)'),
      'width' => 75,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),   
	'company_cname2' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('联系人姓名2(汉语)'),
      'width' => 75,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'phone_setting2' => 
    array(
       'type' => 'varchar(20)',
       'editable' => false,
       'comment' => app::get('b2c')->_('电话区号2'),
    ),
	'company_tel2' => 
    array (
      'type' => 'varchar(30)',
      'label' => app::get('b2c')->_('联系人电话2'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'company_weixin2' => 
    array (
      'type' => 'varchar(50)',
      'label' => app::get('b2c')->_('联系人微信2'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'others_contact' => 
    array (
      'type' => 'text',
      'label' => app::get('b2c')->_('其他联系方式'),
      'width' => 110,
      'filtertype' => 'normal',
      'filterdefault' => 'true',
      'in_list' => true,
      'default_in_list' => false,
    ),
	//=====================================仓库===============================
	'depot_type' => 
    array (
        'type' =>
        array (
            0 => app::get('b2c')->_('Lublino'),
            1 => app::get('b2c')->_('HY仓库'),
            2 => app::get('b2c')->_('其他'),
        ),
        'default' => '0',
        'required' => true,
        'label' => app::get('b2c')->_('仓库类型'),
        'default_in_list' => false,
    ),
    
	'depot_addr' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('出货仓库地址'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'lnumber' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('Lublino店铺编号'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'in_list' => true,
      'default_in_list' => false,
      
    ),
	'check_time' =>
    array(
      'type' => 'time',
      'label' => app::get('b2c')->_('商检证到期日期'),
    ),
	'is_agency' =>
    array (
      'type' => 'bool',
      'required' => true,
      'default' => 'false',
      'label' => app::get('b2c')->_('是否有代理授权'),//（true：是；false：否）
      'width' => 110,
      'editable' => false,
      'in_list' => true,
    ),
	'crm_number' => 
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('CRM客户编码'),
      'width' => 110,
      'editable' => true,
      'filtertype' => 'normal',
      'in_list' => true,
      'default_in_list' => false,
    ),
	'is_wuliu' =>
    array (
      'type' => 'bool',
      'required' => true,
      'default' => 'false',
      'label' => app::get('b2c')->_('是否为物流客户'),//（true：是；false：否）
      'width' => 110,
      'editable' => false,
      'in_list' => true,
    ),
	'is_share' =>
    array (
      'type' => 'bool',
      'required' => true,
      'default' => 'true',
      'label' => app::get('b2c')->_('库存确认'),//（true：需要；false：不需要）
      'width' => 110,
      'editable' => false,
      'in_list' => true,
	  'filtertype' => 'yes',
      'filterdefault' => true,
    ),
	'operator_id' =>
	array (
		'type' => 'number',
		'default' => 0,
		'required' => true,
		'editable' => false,
		'comment' => app::get('b2c')->_('操作员ID'),
		'label' => app::get('b2c')->_('操作员ID'),
		'width' => 150,
		'filtertype' => 'yes',
		'filterdefault' => 'true',
		'in_list' => true,
		'default_in_list' => false,
	 ),
),
	'engine' => 'innodb',
	'version' => '$Rev$',
	'comment' => app::get('b2c')->_('供应商基本信息表'),
);